2012-11-15 - 5388.100 - Spec - Mexico ETI Pedimento Customs Number #Billing #Mexico
5388.100 - Mexico ETI Pedimento Customs Number
Summary Description
Mexico ETI Pedimento Customs Number
Admin Info
Purpose
|
Find a free text field in the delivery to add data to carry over to the invoice
|
Requested by
|
Thi Tran
|
Issue Date
|
11/15/2012
|
Resolved by
|
Surya Basa
|
Resolved Date
|
11/16/2012
|
Document Status
|
Complete
|
Detailed Description
(Include Screen Shots if required )
Originally, the Mexico ETI extracts for the SD and FI/CO programs are passing the creation timestamp of when the invoice is created. Because we are two hours ahead of the government in Mexico, our timestamps were considered future date and were rejected. To get around that, we are currently passing 00:00:00, but it seems now, that any invoice sent with on the same date (time included), same amount and customer are considered duplicate invoices and are rejected. So we need to pass a real timestamp.
For example, if an invoice is created on November 13, 2012 at 08:13:23, the date and time in the extract should be November 13, 2012 at 05:13:23. If the invoice is created on October 13, 2012 at 02:45:34, the date and time in the extract should be October 12, 2012 at 23:45:34.
Analysis and Recommendations
(Include Screen Shots if required)
Delivery texts are not copied to the invoice as the config to copy delivery texts to Invoices are contained in the Transports-
1. NEDK911447 SD: Copy delivery texts for all languages" is not moved to NEP. Once, this TR is imported to NEP the texts will be copied to the invoices.
2. NEDK919844 SD:5388:Update Long Text Copy Controls from Deliv to Invoice.
Once the above two transports are moved, the texts will be copied to the invoices.
The creation date and timestamp should be converted to PST and pass that in the extract file. The SD program, ZISD_ETI_INVOICE_EXTRACT, needs to pull VBRK-FKDAT and VBRK-ERZET and convert into PST. The FI/CO program, ZIFI_ETI_INVOICE_EXTRACT, needs to pull BKPF-BLDAT and BKPF-CPUTM and convert to PST.
Two FM's (/OSP/TIMEZONE_DETERMINE and TZ_SYSTEM_GET_TZONE) were used in the two programs to do the time conversions including daylight saving conversions
Resolution
The specified requirements were [[#|completed]] and tested
Release Information
Provide link here to Release Notes